SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_EscuelasSinNovedadesAlumnos
AS
SELECT DISTINCT TOP 100 PERCENT dt.CUISE, o.Nombre, ad.AnioLectivo
FROM         dbo.tb_AlumnoDivision ad INNER JOIN
                      dbo.tb_Divisionestemp dt ON ad.Division = dt.idDivision INNER JOIN
                      dbo.tb_Organizaciones o ON dt.CUISE = o.CUISE
WHERE     (dt.CUISE > 300)
ORDER BY dt.CUISE, ad.AnioLectivo

GO
